package com.ebupt.migu.music.autoTri.Mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.ebupt.migu.music.autoTri.Entity.SingerBlack;
import com.ebupt.migu.music.autoTri.Entity.SingerBlackListBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**   歌手黑名单mapper
 * @author xuhongsong
 * @version 1.0
 * @date 2020/10/10 14:51
 */
@Mapper
@DS("mysql_mg")
public interface SingerBlackListMapper {

    /**
     *  新增歌手黑名单
     * @param singerBlackListBean
     * @return
     */
    int  add(SingerBlackListBean singerBlackListBean);

    /**
     *  删除歌手黑名单
     * @param map
     * @return
     */
    int  updateStatus(Map<String,Object> map);

    /**
     *  批量删除歌手黑名单
     * @param map
     * @return
     */
    int batchUpdateStatus(Map<String,Object>   map);
    /**
     *   分页查询
     * @return
     */
    List<HashMap<String, Object>> SingerBlackListBeanList(Map<String,Object>  map);
    /**
     *   分页查询总数
     * @return
     */
    int   total(Map<String,Object>  map);

    /**
     *   有效期内的歌手id
     * @return
     */
    List<String>  singerIdList();


    /**
     *  批量新增
     * @param list
     */
    int insertBatchSingerBlackList(List<SingerBlackListBean> list);

    /**
     *  获取所有处于有效状态下的歌手黑名单
     * @return
     */
    List<SingerBlack> getSingerList();
}
